/****** Object:  View [dbo].[Customer and Suppliers by City]    Script Date: 06/12/2011 01:42:52 ******/
DROP VIEW [dbo].[Customer and Suppliers by City]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[Customer and Suppliers by City] AS
SELECT City, CompanyName, ContactName, 'Customers' AS Relationship 
FROM Customers
UNION SELECT City, CompanyName, ContactName, 'Suppliers'
FROM Suppliers
--ORDER BY City, CompanyName
GO
